CREATE TABLE [dbo].[administratie] (
	[naamcode] [char] (4) NOT NULL ,
	[straat] [varchar] (50) NULL ,
	[nr] [varchar] (5) NULL ,
	[busNr] [varchar] (5) NULL ,
	[postcode] [varchar] (50) NULL ,
	[gemeente] [varchar] (50) NULL ,
	[telefoon] [varchar] (30) NULL ,
	[telefoon2] [varchar] (30) NULL ,
	[telefoon3] [varchar] (30) NULL ,
	[email] [varchar] (50) NULL ,
	[geboortedatum] [datetime] NULL ,
	[stamnummer] [varchar] (50) NULL ,
	[geneeskundigNummer] [varchar] (50) NULL ,
	[diploma] [varchar] (50) NULL ,
	[functie] [varchar] (50) NULL ,
	[lesopdracht] [bit] NULL ,
	[functieBadge] [varchar] (50) NULL ,
	CONSTRAINT [pk_administratie] PRIMARY KEY  NONCLUSTERED 
	(
		[naamcode]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[naamcode]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
) ON [PRIMARY]